using System;
using System.Collections.Generic;
using System.Text;
using Fodee.DataEntity;
using System.Data.SqlClient;

namespace Fodee.DataAccess
{
    public class FoodDA : DataAccess
    {
        public FodeeDataSet SearchFood(string numOrcode)
        {
            numOrcode = "%" + numOrcode + "%";
            DataBase database = new DataBase();
            SqlParameter param = new SqlParameter("@FoodNumOrCode", numOrcode);
            FodeeDataSet ds = new FodeeDataSet();
            database.ExcuteQuery("[P_fod_Food_S_By_NumOrCode]", ds.fod_Food, new SqlParameter[] { param });
            return ds;
        }
    }
}
